Spotify Charts Profiling Report

Dataset statistics

Number of variables	25
Number of observations	402031
Missing cells	88207
Missing cells (%)	0.9%
Duplicate rows	0
Duplicate rows (%)	0.0%
Total size in memory	221.3 MiB
Average record size in memory	577.2 B

Variable types

Numeric	15
Text	4
DateTime	1
Categorical	4
Boolean	1

Alerts

`af_energy` is highly overall correlated with `af_loudness`	High correlation
`af_loudness` is highly overall correlated with `af_energy`	High correlation
`popularity` is highly overall correlated with `predicted_popularity`	High correlation
`predicted_popularity` is highly overall correlated with `popularity`	High correlation
`rank` is highly overall correlated with `streams`	High correlation
`streams` is highly overall correlated with `rank`	High correlation
`af_time_signature` is highly imbalanced (86.8%)	Imbalance
`streams` has 88188 (21.9%) missing values	Missing
`chart_id` has unique values	Unique
`popularity` has 64118 (15.9%) zeros	Zeros
`af_key` has 46729 (11.6%) zeros	Zeros
`af_instrumentalness` has 229419 (57.1%) zeros	Zeros

Reproduction

Analysis started	2024-07-15 01:13:16.477892
Analysis finished	2024-07-15 01:14:37.265169
Duration	1 minute and 20.79 seconds
Software version	ydata-profiling v4.8.3
Download configuration	config.json

chart_id
Real number (ℝ)

UNIQUE

Distinct	402031
Distinct (%)	100.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	12998453

Minimum	803
Maximum	26171075
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	6.1 MiB

Quantile statistics

Minimum	803
5-th percentile	1472789.5
Q1	6427568.5
median	13027021
Q3	19530458
95-th percentile	24623584
Maximum	26171075
Range	26170272
Interquartile range (IQR)	13102890

Descriptive statistics

Standard deviation	7479019.1
Coefficient of variation (CV)	0.57537763
Kurtosis	-1.224669
Mean	12998453
Median Absolute Deviation (MAD)	6561651
Skewness	0.024745339
Sum	5.2257811 × 10¹²
Variance	5.5935726 × 10¹³
Monotonicity	Strictly increasing

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
803	1	< 0.1%
17352925	1	< 0.1%
17352923	1	< 0.1%
17352922	1	< 0.1%
17352921	1	< 0.1%
17352920	1	< 0.1%
17350436	1	< 0.1%
17350435	1	< 0.1%
17350434	1	< 0.1%
17350433	1	< 0.1%
Other values (402021)	402021	> 99.9%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
803	1	< 0.1%
804	1	< 0.1%
805	1	< 0.1%
806	1	< 0.1%
807	1	< 0.1%
808	1	< 0.1%
809	1	< 0.1%
810	1	< 0.1%
811	1	< 0.1%
812	1	< 0.1%

Value	Count	Frequency (%)
26171075	1	< 0.1%
26171074	1	< 0.1%
26171073	1	< 0.1%
26171071	1	< 0.1%
26171070	1	< 0.1%
26171068	1	< 0.1%
26171067	1	< 0.1%
26171066	1	< 0.1%
26171064	1	< 0.1%
26171063	1	< 0.1%

title
Text

Distinct	5080
Distinct (%)	1.3%
Missing	0
Missing (%)	0.0%
Memory size	33.9 MiB

Length

Max length	122
Median length	83
Mean length	15.494733
Min length	1

Characters and Unicode

Total characters	6229363
Distinct characters	183
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	509 ?
Unique (%)	0.1%

Sample

1st row	Reggaetón Lento (Bailemos)
2nd row	Otra vez (feat. J Balvin)
3rd row	Chantaje (feat. Maluma)
4th row	Vente Pa' Ca (feat. Maluma)
5th row	Traicionera

Value	Count	Frequency (%)
	62987	5.3%
feat	45628	3.8%
remix	40383	3.4%
la	24166	2.0%
me	21961	1.8%
te	15160	1.3%
no	13888	1.2%
de	13133	1.1%
a	10634	0.9%
el	10012	0.8%
Other values (5129)	935741	78.4%

Most occurring characters

Value	Count	Frequency (%)
	791662	12.7%
e	559411	9.0%
a	531124	8.5%
o	366982	5.9%
i	322776	5.2%
n	258313	4.1%
t	231832	3.7%
r	226508	3.6%
l	198068	3.2%
s	181209	2.9%
Other values (173)	2561478	41.1%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	6229363	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
	791662	12.7%
e	559411	9.0%
a	531124	8.5%
o	366982	5.9%
i	322776	5.2%
n	258313	4.1%
t	231832	3.7%
r	226508	3.6%
l	198068	3.2%
s	181209	2.9%
Other values (173)	2561478	41.1%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	6229363	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
	791662	12.7%
e	559411	9.0%
a	531124	8.5%
o	366982	5.9%
i	322776	5.2%
n	258313	4.1%
t	231832	3.7%
r	226508	3.6%
l	198068	3.2%
s	181209	2.9%
Other values (173)	2561478	41.1%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	6229363	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
	791662	12.7%
e	559411	9.0%
a	531124	8.5%
o	366982	5.9%
i	322776	5.2%
n	258313	4.1%
t	231832	3.7%
r	226508	3.6%
l	198068	3.2%
s	181209	2.9%
Other values (173)	2561478	41.1%

rank
Real number (ℝ)

HIGH CORRELATION

Distinct	200
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	76.899617

Minimum	1
Maximum	200
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	6.1 MiB

Quantile statistics

Minimum	1
5-th percentile	6
Q1	28
median	62
Q3	121
95-th percentile	183
Maximum	200
Range	199
Interquartile range (IQR)	93

Descriptive statistics

Standard deviation	56.935098
Coefficient of variation (CV)	0.74038208
Kurtosis	-0.92384711
Mean	76.899617
Median Absolute Deviation (MAD)	41
Skewness	0.54223727
Sum	30916030
Variance	3241.6054
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
1	3638	0.9%
2	3638	0.9%
6	3624	0.9%
5	3622	0.9%
3	3620	0.9%
7	3613	0.9%
8	3613	0.9%
4	3613	0.9%
10	3611	0.9%
11	3606	0.9%
Other values (190)	365833	91.0%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1	3638	0.9%
2	3638	0.9%
3	3620	0.9%
4	3613	0.9%
5	3622	0.9%
6	3624	0.9%
7	3613	0.9%
8	3613	0.9%
9	3592	0.9%
10	3611	0.9%

Value	Count	Frequency (%)
200	1140	0.3%
199	1141	0.3%
198	1144	0.3%
197	1149	0.3%
196	1151	0.3%
195	1153	0.3%
194	1159	0.3%
193	1163	0.3%
192	1163	0.3%
191	1164	0.3%

date
Date

Distinct	1826
Distinct (%)	0.5%
Missing	0
Missing (%)	0.0%
Memory size	6.1 MiB

Minimum	2017-01-01 00:00:00
Maximum	2021-12-31 00:00:00

Histogram

Histogram with fixed size bins (bins=50)

artist
Text

Distinct	3267
Distinct (%)	0.8%
Missing	0
Missing (%)	0.0%
Memory size	34.2 MiB

Length

Max length	421
Median length	102
Mean length	18.462051
Min length	1

Characters and Unicode

Total characters	7422317
Distinct characters	147
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	230 ?
Unique (%)	0.1%

Sample

1st row	CNCO
2nd row	Zion & Lennox
3rd row	Shakira
4th row	Ricky Martin
5th row	Sebastian Yatra

Value	Count	Frequency (%)
bunny	29398	2.4%
bad	29348	2.4%
j	24052	1.9%
balvin	23747	1.9%
ozuna	18286	1.5%
sebastian	16200	1.3%
yatra	16158	1.3%
g	16028	1.3%
maluma	14463	1.2%
alejandro	14153	1.1%
Other values (3566)	1044588	83.8%

Most occurring characters

Value	Count	Frequency (%)
	844390	11.4%
a	751016	10.1%
e	503412	6.8%
n	485450	6.5%
i	395387	5.3%
o	335845	4.5%
,	322342	4.3%
r	306537	4.1%
l	300188	4.0%
u	237799	3.2%
Other values (137)	2939951	39.6%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	7422317	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
	844390	11.4%
a	751016	10.1%
e	503412	6.8%
n	485450	6.5%
i	395387	5.3%
o	335845	4.5%
,	322342	4.3%
r	306537	4.1%
l	300188	4.0%
u	237799	3.2%
Other values (137)	2939951	39.6%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	7422317	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
	844390	11.4%
a	751016	10.1%
e	503412	6.8%
n	485450	6.5%
i	395387	5.3%
o	335845	4.5%
,	322342	4.3%
r	306537	4.1%
l	300188	4.0%
u	237799	3.2%
Other values (137)	2939951	39.6%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	7422317	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
	844390	11.4%
a	751016	10.1%
e	503412	6.8%
n	485450	6.5%
i	395387	5.3%
o	335845	4.5%
,	322342	4.3%
r	306537	4.1%
l	300188	4.0%
u	237799	3.2%
Other values (137)	2939951	39.6%

trend
Categorical

Distinct	4
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	28.3 MiB

MOVE_DOWN	168117
MOVE_UP	150412
SAME_POSITION	57643
NEW_ENTRY	25859

Length

Max length	13
Median length	9
Mean length	8.8252573
Min length	7

Characters and Unicode

Total characters	3548027
Distinct characters	16
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	SAME_POSITION
2nd row	SAME_POSITION
3rd row	SAME_POSITION
4th row	MOVE_UP
5th row	MOVE_DOWN

Common Values

Value	Count	Frequency (%)
MOVE_DOWN	168117	41.8%
MOVE_UP	150412	37.4%
SAME_POSITION	57643	14.3%
NEW_ENTRY	25859	6.4%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
move_down	168117	41.8%
move_up	150412	37.4%
same_position	57643	14.3%
new_entry	25859	6.4%

Most occurring characters

Value	Count	Frequency (%)
O	601932	17.0%
E	427890	12.1%
_	402031	11.3%
M	376172	10.6%
V	318529	9.0%
N	277478	7.8%
P	208055	5.9%
W	193976	5.5%
D	168117	4.7%
U	150412	4.2%
Other values (6)	423435	11.9%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	3548027	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
O	601932	17.0%
E	427890	12.1%
_	402031	11.3%
M	376172	10.6%
V	318529	9.0%
N	277478	7.8%
P	208055	5.9%
W	193976	5.5%
D	168117	4.7%
U	150412	4.2%
Other values (6)	423435	11.9%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	3548027	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
O	601932	17.0%
E	427890	12.1%
_	402031	11.3%
M	376172	10.6%
V	318529	9.0%
N	277478	7.8%
P	208055	5.9%
W	193976	5.5%
D	168117	4.7%
U	150412	4.2%
Other values (6)	423435	11.9%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	3548027	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
O	601932	17.0%
E	427890	12.1%
_	402031	11.3%
M	376172	10.6%
V	318529	9.0%
N	277478	7.8%
P	208055	5.9%
W	193976	5.5%
D	168117	4.7%
U	150412	4.2%
Other values (6)	423435	11.9%

streams
Real number (ℝ)

HIGH CORRELATION MISSING

Distinct	17907
Distinct (%)	5.7%
Missing	88188
Missing (%)	21.9%
Infinite	0
Infinite (%)	0.0%
Mean	3731.0066

Minimum	1001
Maximum	81858
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	6.1 MiB

Quantile statistics

Minimum	1001
5-th percentile	1140
Q1	1796
median	2629
Q3	4142
95-th percentile	10155
Maximum	81858
Range	80857
Interquartile range (IQR)	2346

Descriptive statistics

Standard deviation	3543.2684
Coefficient of variation (CV)	0.94968162
Kurtosis	26.978097
Mean	3731.0066
Median Absolute Deviation (MAD)	1008
Skewness	3.9326684
Sum	1.1709503 × 10⁹
Variance	12554751
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
1021	143	< 0.1%
1038	139	< 0.1%
1043	134	< 0.1%
1033	134	< 0.1%
1184	133	< 0.1%
1024	133	< 0.1%
1019	133	< 0.1%
1039	132	< 0.1%
1008	131	< 0.1%
1010	131	< 0.1%
Other values (17897)	312500	77.7%
(Missing)	88188	21.9%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1001	116	< 0.1%
1002	129	< 0.1%
1003	118	< 0.1%
1004	129	< 0.1%
1005	100	< 0.1%
1006	129	< 0.1%
1007	131	< 0.1%
1008	131	< 0.1%
1009	115	< 0.1%
1010	131	< 0.1%

Value	Count	Frequency (%)
81858	1	< 0.1%
71779	1	< 0.1%
68209	1	< 0.1%
64255	1	< 0.1%
63590	1	< 0.1%
62765	1	< 0.1%
62750	1	< 0.1%
62483	1	< 0.1%
62437	1	< 0.1%
61086	1	< 0.1%

track_id
Text

Distinct	6053
Distinct (%)	1.5%
Missing	0
Missing (%)	0.0%
Memory size	33.4 MiB

Length

Max length	22
Median length	22
Mean length	22
Min length	22

Characters and Unicode

Total characters	8844682
Distinct characters	62
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	681 ?
Unique (%)	0.2%

Sample

1st row	3AEZUABDXNtecAOSC1qTfo
2nd row	3QwBODjSEzelZyVjxPOHdq
3rd row	6mICuAdrwEjh6Y6lroV2Kg
4th row	7DM4BPaS7uofFul3ywMe46
5th row	5J1c3M4EldCfNxXwrwt8mT

Value	Count	Frequency (%)
7qizfu4dy1lwllzx7mpbi3	1252	0.3%
059bcihyc2sbwm6sw2azzd	1250	0.3%
3qwbodjsezelzyvjxpohdq	1196	0.3%
0pqnghjpmpxlkifkrmu6wp	1181	0.3%
1j6xogusnyxq3l6irykf3g	1155	0.3%
7dhyjnlksxzhbrqeheaums	1145	0.3%
4r8bjggjostswlxtkw8v7p	1110	0.3%
4nut1fcno9aqaelbgxq3kr	1097	0.3%
0fea68admynygetgi4rc18	1088	0.3%
2th65lnhgvlxckxm3apjxi	1075	0.3%
Other values (6043)	390482	97.1%

Most occurring characters

Value	Count	Frequency (%)
1	202965	2.3%
2	192148	2.2%
3	190146	2.1%
4	188939	2.1%
0	188245	2.1%
6	187266	2.1%
7	184563	2.1%
5	178010	2.0%
w	155010	1.8%
q	152055	1.7%
Other values (52)	7025335	79.4%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	8844682	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
1	202965	2.3%
2	192148	2.2%
3	190146	2.1%
4	188939	2.1%
0	188245	2.1%
6	187266	2.1%
7	184563	2.1%
5	178010	2.0%
w	155010	1.8%
q	152055	1.7%
Other values (52)	7025335	79.4%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	8844682	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
1	202965	2.3%
2	192148	2.2%
3	190146	2.1%
4	188939	2.1%
0	188245	2.1%
6	187266	2.1%
7	184563	2.1%
5	178010	2.0%
w	155010	1.8%
q	152055	1.7%
Other values (52)	7025335	79.4%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	8844682	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
1	202965	2.3%
2	192148	2.2%
3	190146	2.1%
4	188939	2.1%
0	188245	2.1%
6	187266	2.1%
7	184563	2.1%
5	178010	2.0%
w	155010	1.8%
q	152055	1.7%
Other values (52)	7025335	79.4%

album
Text

Distinct	4450
Distinct (%)	1.1%
Missing	19
Missing (%)	< 0.1%
Memory size	33.2 MiB

Length

Max length	122
Median length	85
Mean length	14.693243
Min length	1

Characters and Unicode

Total characters	5906860
Distinct characters	182
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	370 ?
Unique (%)	0.1%

Sample

1st row	Primera Cita
2nd row	Motivan2
3rd row	El Dorado
4th row	Vente Pa' Ca (feat. Maluma)
5th row	Traicionera

Value	Count	Frequency (%)
remix	31649	2.9%
feat	29572	2.7%
	21026	1.9%
la	16211	1.5%
el	13762	1.3%
me	13648	1.3%
the	12939	1.2%
de	11213	1.0%
a	10609	1.0%
te	9595	0.9%
Other values (4984)	909398	84.2%

Most occurring characters

Value	Count	Frequency (%)
	677610	11.5%
e	489412	8.3%
a	452205	7.7%
o	337196	5.7%
i	298053	5.0%
n	230693	3.9%
r	224765	3.8%
t	196180	3.3%
l	193703	3.3%
s	175534	3.0%
Other values (172)	2631509	44.6%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	5906860	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
	677610	11.5%
e	489412	8.3%
a	452205	7.7%
o	337196	5.7%
i	298053	5.0%
n	230693	3.9%
r	224765	3.8%
t	196180	3.3%
l	193703	3.3%
s	175534	3.0%
Other values (172)	2631509	44.6%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	5906860	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
	677610	11.5%
e	489412	8.3%
a	452205	7.7%
o	337196	5.7%
i	298053	5.0%
n	230693	3.9%
r	224765	3.8%
t	196180	3.3%
l	193703	3.3%
s	175534	3.0%
Other values (172)	2631509	44.6%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	5906860	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
	677610	11.5%
e	489412	8.3%
a	452205	7.7%
o	337196	5.7%
i	298053	5.0%
n	230693	3.9%
r	224765	3.8%
t	196180	3.3%
l	193703	3.3%
s	175534	3.0%
Other values (172)	2631509	44.6%

popularity
Real number (ℝ)

HIGH CORRELATION ZEROS

Distinct	92
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	54.175805

Minimum	0
Maximum	91
Zeros	64118
Zeros (%)	15.9%
Negative	0
Negative (%)	0.0%
Memory size	6.1 MiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	49
median	65
Q3	73
95-th percentile	82
Maximum	91
Range	91
Interquartile range (IQR)	24

Descriptive statistics

Standard deviation	27.880608
Coefficient of variation (CV)	0.51463209
Kurtosis	-0.21729518
Mean	54.175805
Median Absolute Deviation (MAD)	10
Skewness	-1.1184368
Sum	21780353
Variance	777.32828
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	64118	15.9%
74	16892	4.2%
68	14935	3.7%
70	13344	3.3%
73	12922	3.2%
69	12365	3.1%
78	12295	3.1%
75	11479	2.9%
67	11444	2.8%
76	11218	2.8%
Other values (82)	221019	55.0%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	64118	15.9%
1	3281	0.8%
2	1681	0.4%
3	867	0.2%
4	739	0.2%
5	926	0.2%
6	342	0.1%
7	1342	0.3%
8	187	< 0.1%
9	114	< 0.1%

Value	Count	Frequency (%)
91	5	< 0.1%
90	782	0.2%
89	764	0.2%
88	2668	0.7%
87	2318	0.6%
86	3966	1.0%
85	2572	0.6%
84	3308	0.8%
83	3182	0.8%
82	2891	0.7%

duration_ms
Real number (ℝ)

Distinct	5106
Distinct (%)	1.3%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	214391.34

Minimum	0
Maximum	720000
Zeros	19
Zeros (%)	< 0.1%
Negative	0
Negative (%)	0.0%
Memory size	6.1 MiB

Quantile statistics

Minimum	0
5-th percentile	157890
Q1	188560
median	209180
Q3	231848
95-th percentile	295176
Maximum	720000
Range	720000
Interquartile range (IQR)	43288

Descriptive statistics

Standard deviation	42649.001
Coefficient of variation (CV)	0.19893062
Kurtosis	4.6928473
Mean	214391.34
Median Absolute Deviation (MAD)	21752
Skewness	1.3293303
Sum	8.6191963 × 10¹⁰
Variance	1.8189373 × 10⁹
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
205714	2063	0.5%
204346	1661	0.4%
220116	1533	0.4%
233712	1305	0.3%
231848	1250	0.3%
209453	1196	0.3%
266160	1145	0.3%
309120	1110	0.3%
174000	1104	0.3%
231773	1097	0.3%
Other values (5096)	388567	96.7%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	19	< 0.1%
41454	6	< 0.1%
46889	2	< 0.1%
58149	44	< 0.1%
62422	1	< 0.1%
66226	2	< 0.1%
67996	1	< 0.1%
68205	8	< 0.1%
68522	1	< 0.1%
69813	40	< 0.1%

Value	Count	Frequency (%)
720000	6	< 0.1%
621106	4	< 0.1%
620101	3	< 0.1%
613026	31	< 0.1%
581728	2	< 0.1%
544626	5	< 0.1%
522000	3	< 0.1%
520786	7	< 0.1%
512093	1	< 0.1%
502186	4	< 0.1%

explicit
Boolean

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	3.5 MiB

False	320979
True	81052

Common Values (Table)
Common Values (Plot)

Value	Count	Frequency (%)
False	320979	79.8%
True	81052	20.2%

af_danceability
Real number (ℝ)

Distinct	679
Distinct (%)	0.2%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	0.72220811

Minimum	0.0783
Maximum	0.98
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	6.1 MiB

Quantile statistics

Minimum	0.0783
5-th percentile	0.498
Q1	0.672
median	0.743
Q3	0.8
95-th percentile	0.871
Maximum	0.98
Range	0.9017
Interquartile range (IQR)	0.128

Descriptive statistics

Standard deviation	0.11414508
Coefficient of variation (CV)	0.15805012
Kurtosis	1.61492
Mean	0.72220811
Median Absolute Deviation (MAD)	0.063
Skewness	-1.1031197
Sum	290350.05
Variance	0.0130291
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0.744	3886	1.0%
0.795	3787	0.9%
0.76	3681	0.9%
0.807	3248	0.8%
0.762	3215	0.8%
0.728	3134	0.8%
0.823	3057	0.8%
0.817	2986	0.7%
0.826	2905	0.7%
0.684	2856	0.7%
Other values (669)	369276	91.9%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0.0783	59	< 0.1%
0.0986	3	< 0.1%
0.15	41	< 0.1%
0.161	1	< 0.1%
0.168	7	< 0.1%
0.179	14	< 0.1%
0.181	7	< 0.1%
0.201	4	< 0.1%
0.207	24	< 0.1%
0.209	4	< 0.1%

Value	Count	Frequency (%)
0.98	79	< 0.1%
0.967	45	< 0.1%
0.964	178	< 0.1%
0.963	26	< 0.1%
0.962	7	< 0.1%
0.96	4	< 0.1%
0.959	8	< 0.1%
0.957	13	< 0.1%
0.956	55	< 0.1%
0.955	25	< 0.1%

af_energy
Real number (ℝ)

HIGH CORRELATION

Distinct	805
Distinct (%)	0.2%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	0.68419158

Minimum	0.0188
Maximum	0.999
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	6.1 MiB

Quantile statistics

Minimum	0.0188
5-th percentile	0.413
Q1	0.603
median	0.709
Q3	0.79
95-th percentile	0.876
Maximum	0.999
Range	0.9802
Interquartile range (IQR)	0.187

Descriptive statistics

Standard deviation	0.14587189
Coefficient of variation (CV)	0.21320329
Kurtosis	0.71377742
Mean	0.68419158
Median Absolute Deviation (MAD)	0.09
Skewness	-0.83707575
Sum	275066.23
Variance	0.021278609
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0.773	3648	0.9%
0.724	3389	0.8%
0.859	3199	0.8%
0.791	2961	0.7%
0.712	2945	0.7%
0.672	2749	0.7%
0.838	2731	0.7%
0.731	2687	0.7%
0.745	2550	0.6%
0.771	2541	0.6%
Other values (795)	372631	92.7%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0.0188	3	< 0.1%
0.0305	2	< 0.1%
0.0413	50	< 0.1%
0.0513	2	< 0.1%
0.0561	7	< 0.1%
0.0568	7	< 0.1%
0.0809	9	< 0.1%
0.0828	2	< 0.1%
0.0829	2	< 0.1%
0.0842	12	< 0.1%

Value	Count	Frequency (%)
0.999	3	< 0.1%
0.998	7	< 0.1%
0.995	11	< 0.1%
0.993	7	< 0.1%
0.99	7	< 0.1%
0.989	66	< 0.1%
0.988	70	< 0.1%
0.978	18	< 0.1%
0.977	7	< 0.1%
0.975	6	< 0.1%

af_key
Real number (ℝ)

ZEROS

Distinct	12
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	5.3391903

Minimum	0
Maximum	11
Zeros	46729
Zeros (%)	11.6%
Negative	0
Negative (%)	0.0%
Memory size	6.1 MiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	1
median	6
Q3	9
95-th percentile	11
Maximum	11
Range	11
Interquartile range (IQR)	8

Descriptive statistics

Standard deviation	3.6959745
Coefficient of variation (CV)	0.69223503
Kurtosis	-1.3346966
Mean	5.3391903
Median Absolute Deviation (MAD)	3
Skewness	-0.009895131
Sum	2146520
Variance	13.660228
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=12)

Value	Count	Frequency (%)
1	54685	13.6%
0	46729	11.6%
11	42521	10.6%
6	38011	9.5%
7	36158	9.0%
9	34166	8.5%
5	33362	8.3%
8	30727	7.6%
2	30320	7.5%
10	25056	6.2%
Other values (2)	30296	7.5%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	46729	11.6%
1	54685	13.6%
2	30320	7.5%
3	9572	2.4%
4	20724	5.2%
5	33362	8.3%
6	38011	9.5%
7	36158	9.0%
8	30727	7.6%
9	34166	8.5%

Value	Count	Frequency (%)
11	42521	10.6%
10	25056	6.2%
9	34166	8.5%
8	30727	7.6%
7	36158	9.0%
6	38011	9.5%
5	33362	8.3%
4	20724	5.2%
3	9572	2.4%
2	30320	7.5%

af_loudness
Real number (ℝ)

HIGH CORRELATION

Distinct	4071
Distinct (%)	1.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	-5.2027539

Minimum	-30.663
Maximum	1.509
Zeros	0
Zeros (%)	0.0%
Negative	401969
Negative (%)	> 99.9%
Memory size	6.1 MiB

Quantile statistics

Minimum	-30.663
5-th percentile	-9.096
Q1	-6.169
median	-4.791
Q3	-3.855
95-th percentile	-2.657
Maximum	1.509
Range	32.172
Interquartile range (IQR)	2.314

Descriptive statistics

Standard deviation	2.1079685
Coefficient of variation (CV)	-0.40516399
Kurtosis	5.7531305
Mean	-5.2027539
Median Absolute Deviation (MAD)	1.123
Skewness	-1.6784627
Sum	-2091668.4
Variance	4.4435314
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
-6.327	1859	0.5%
-4.323	1789	0.4%
-7.125	1759	0.4%
-5.119	1629	0.4%
-4.773	1503	0.4%
-4.803	1481	0.4%
-3.183	1307	0.3%
-4.246	1250	0.3%
-5.429	1197	0.3%
-4.374	1181	0.3%
Other values (4061)	387076	96.3%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
-30.663	2	< 0.1%
-27.666	5	< 0.1%
-26.574	4	< 0.1%
-26.129	2	< 0.1%
-23.597	3	< 0.1%
-23.274	3	< 0.1%
-23.128	7	< 0.1%
-23.023	7	< 0.1%
-22.867	3	< 0.1%
-22.602	5	< 0.1%

Value	Count	Frequency (%)
1.509	7	< 0.1%
0.302	17	< 0.1%
0.175	38	< 0.1%
-0.02	13	< 0.1%
-0.515	277	0.1%
-0.521	25	< 0.1%
-0.582	104	< 0.1%
-0.604	20	< 0.1%
-0.739	119	< 0.1%
-0.776	13	< 0.1%

af_mode
Categorical

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	26.1 MiB

1.0	236472
0.0	165559

Length

Max length	3
Median length	3
Mean length	3
Min length	3

Characters and Unicode

Total characters	1206093
Distinct characters	3
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	0.0
2nd row	1.0
3rd row	0.0
4th row	0.0
5th row	1.0

Common Values

Value	Count	Frequency (%)
1.0	236472	58.8%
0.0	165559	41.2%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
1.0	236472	58.8%
0.0	165559	41.2%

Most occurring characters

Value	Count	Frequency (%)
0	567590	47.1%
.	402031	33.3%
1	236472	19.6%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	1206093	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
0	567590	47.1%
.	402031	33.3%
1	236472	19.6%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	1206093	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
0	567590	47.1%
.	402031	33.3%
1	236472	19.6%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	1206093	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
0	567590	47.1%
.	402031	33.3%
1	236472	19.6%

af_speechiness
Real number (ℝ)

Distinct	1071
Distinct (%)	0.3%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	0.11146009

Minimum	0.0231
Maximum	0.884
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	6.1 MiB

Quantile statistics

Minimum	0.0231
5-th percentile	0.0325
Q1	0.0512
median	0.0779
Q3	0.14
95-th percentile	0.312
Maximum	0.884
Range	0.8609
Interquartile range (IQR)	0.0888

Descriptive statistics

Standard deviation	0.087719262
Coefficient of variation (CV)	0.78700152
Kurtosis	2.7127404
Mean	0.11146009
Median Absolute Deviation (MAD)	0.0343
Skewness	1.6771008
Sum	44810.412
Variance	0.0076946689
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0.113	2481	0.6%
0.103	2432	0.6%
0.1	2398	0.6%
0.0785	2219	0.6%
0.154	2210	0.5%
0.111	2178	0.5%
0.0432	2086	0.5%
0.2	2064	0.5%
0.109	2028	0.5%
0.129	2018	0.5%
Other values (1061)	379917	94.5%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0.0231	7	< 0.1%
0.0232	822	0.2%
0.0235	79	< 0.1%
0.0236	9	< 0.1%
0.024	37	< 0.1%
0.0243	562	0.1%
0.0245	7	< 0.1%
0.0247	20	< 0.1%
0.0248	1	< 0.1%
0.0249	17	< 0.1%

Value	Count	Frequency (%)
0.884	11	< 0.1%
0.777	41	< 0.1%
0.733	3	< 0.1%
0.717	1	< 0.1%
0.649	7	< 0.1%
0.607	4	< 0.1%
0.594	14	< 0.1%
0.556	37	< 0.1%
0.547	37	< 0.1%
0.53	26	< 0.1%

af_acousticness
Real number (ℝ)

Distinct	1929
Distinct (%)	0.5%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	0.23930709

Minimum	6.11 × 10^-6
Maximum	0.995
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	6.1 MiB

Quantile statistics

Minimum	6.11 × 10^-6
5-th percentile	0.0132
Q1	0.0728
median	0.178
Q3	0.346
95-th percentile	0.689
Maximum	0.995
Range	0.99499389
Interquartile range (IQR)	0.2732

Descriptive statistics

Standard deviation	0.21324725
Coefficient of variation (CV)	0.89110292
Kurtosis	1.1079483
Mean	0.23930709
Median Absolute Deviation (MAD)	0.1232
Skewness	1.2463239
Sum	96208.868
Variance	0.045474388
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0.176	3479	0.9%
0.186	2897	0.7%
0.237	2803	0.7%
0.323	2443	0.6%
0.125	2374	0.6%
0.161	2370	0.6%
0.175	2361	0.6%
0.11	2262	0.6%
0.39	2007	0.5%
0.14	1972	0.5%
Other values (1919)	377063	93.8%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
6.11 × 10^-6	2	< 0.1%
6.52 × 10^-6	1	< 0.1%
1.05 × 10^-5	3	< 0.1%
2.67 × 10^-5	7	< 0.1%
2.95 × 10^-5	14	< 0.1%
3.12 × 10^-5	1	< 0.1%
3.62 × 10^-5	2	< 0.1%
3.84 × 10^-5	173	< 0.1%
4.16 × 10^-5	19	< 0.1%
5.54 × 10^-5	14	< 0.1%

Value	Count	Frequency (%)
0.995	5	< 0.1%
0.992	4	< 0.1%
0.991	9	< 0.1%
0.99	12	< 0.1%
0.989	40	< 0.1%
0.988	3	< 0.1%
0.987	2	< 0.1%
0.986	9	< 0.1%
0.985	435	0.1%
0.984	332	0.1%

af_instrumentalness
Real number (ℝ)

ZEROS

Distinct	1898
Distinct (%)	0.5%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	0.0077434446

Minimum	0
Maximum	0.981
Zeros	229419
Zeros (%)	57.1%
Negative	0
Negative (%)	0.0%
Memory size	6.1 MiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0
Q3	1.83 × 10^-5
95-th percentile	0.00375
Maximum	0.981
Range	0.981
Interquartile range (IQR)	1.83 × 10^-5

Descriptive statistics

Standard deviation	0.064890654
Coefficient of variation (CV)	8.3800759
Kurtosis	126.19733
Mean	0.0077434446
Median Absolute Deviation (MAD)	0
Skewness	10.825889
Sum	3113.1048
Variance	0.004210797
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	229419	57.1%
1.85 × 10^-5	1406	0.3%
2.12 × 10^-6	1402	0.3%
1.14 × 10^-6	1278	0.3%
3.46 × 10^-5	1250	0.3%
1.58 × 10^-6	1207	0.3%
0.000486	1196	0.3%
1.02 × 10^-5	1133	0.3%
2.02 × 10^-5	1043	0.3%
4.21 × 10^-6	1041	0.3%
Other values (1888)	161656	40.2%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	229419	57.1%
1 × 10^-6	242	0.1%
1.01 × 10^-6	62	< 0.1%
1.02 × 10^-6	302	0.1%
1.03 × 10^-6	6	< 0.1%
1.04 × 10^-6	28	< 0.1%
1.05 × 10^-6	16	< 0.1%
1.06 × 10^-6	27	< 0.1%
1.07 × 10^-6	127	< 0.1%
1.08 × 10^-6	58	< 0.1%

Value	Count	Frequency (%)
0.981	3	< 0.1%
0.975	1	< 0.1%
0.97	1	< 0.1%
0.964	7	< 0.1%
0.961	45	< 0.1%
0.953	11	< 0.1%
0.951	4	< 0.1%
0.95	2	< 0.1%
0.949	6	< 0.1%
0.948	2	< 0.1%

af_liveness
Real number (ℝ)

Distinct	1121
Distinct (%)	0.3%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	0.16355626

Minimum	0.019
Maximum	0.98
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	6.1 MiB

Quantile statistics

Minimum	0.019
5-th percentile	0.0574
Q1	0.0897
median	0.118
Q3	0.195
95-th percentile	0.386
Maximum	0.98
Range	0.961
Interquartile range (IQR)	0.1053

Descriptive statistics

Standard deviation	0.12273211
Coefficient of variation (CV)	0.7503969
Kurtosis	7.2752239
Mean	0.16355626
Median Absolute Deviation (MAD)	0.037
Skewness	2.3523927
Sum	65754.686
Variance	0.015063171
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0.106	6347	1.6%
0.101	5415	1.3%
0.103	5056	1.3%
0.108	4474	1.1%
0.102	4399	1.1%
0.107	3922	1.0%
0.104	3908	1.0%
0.123	3777	0.9%
0.11	3776	0.9%
0.128	3757	0.9%
Other values (1111)	357200	88.8%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0.019	7	< 0.1%
0.0202	15	< 0.1%
0.0207	171	< 0.1%
0.0215	106	< 0.1%
0.0219	24	< 0.1%
0.024	177	< 0.1%
0.0243	13	< 0.1%
0.0247	2	< 0.1%
0.0251	65	< 0.1%
0.0258	4	< 0.1%

Value	Count	Frequency (%)
0.98	2	< 0.1%
0.978	61	< 0.1%
0.976	6	< 0.1%
0.974	2	< 0.1%
0.971	2	< 0.1%
0.968	22	< 0.1%
0.963	3	< 0.1%
0.962	7	< 0.1%
0.961	18	< 0.1%
0.96	5	< 0.1%

af_valence
Real number (ℝ)

Distinct	935
Distinct (%)	0.2%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	0.61697346

Minimum	0.032
Maximum	0.982
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	6.1 MiB

Quantile statistics

Minimum	0.032
5-th percentile	0.215
Q1	0.478
median	0.652
Q3	0.78
95-th percentile	0.911
Maximum	0.982
Range	0.95
Interquartile range (IQR)	0.302

Descriptive statistics

Standard deviation	0.20867749
Coefficient of variation (CV)	0.33822767
Kurtosis	-0.47601676
Mean	0.61697346
Median Absolute Deviation (MAD)	0.144
Skewness	-0.51557593
Sum	248042.46
Variance	0.043546297
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0.68	3026	0.8%
0.839	2415	0.6%
0.761	2377	0.6%
0.706	2219	0.6%
0.695	2153	0.5%
0.637	2085	0.5%
0.619	2075	0.5%
0.78	2062	0.5%
0.71	2000	0.5%
0.618	1980	0.5%
Other values (925)	379639	94.4%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0.032	15	< 0.1%
0.0348	5	< 0.1%
0.036	45	< 0.1%
0.0378	13	< 0.1%
0.038	31	< 0.1%
0.0386	3	< 0.1%
0.0392	19	< 0.1%
0.0393	64	< 0.1%
0.0395	5	< 0.1%
0.0398	51	< 0.1%

Value	Count	Frequency (%)
0.982	11	< 0.1%
0.98	14	< 0.1%
0.978	1	< 0.1%
0.976	10	< 0.1%
0.975	7	< 0.1%
0.974	7	< 0.1%
0.973	136	< 0.1%
0.971	2	< 0.1%
0.969	2	< 0.1%
0.968	75	< 0.1%

af_tempo
Real number (ℝ)

Distinct	4930
Distinct (%)	1.2%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	123.73679

Minimum	48.936
Maximum	214.131
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	6.1 MiB

Quantile statistics

Minimum	48.936
5-th percentile	83.836
Q1	94.059
median	109.326
Q3	160.007
95-th percentile	180.073
Maximum	214.131
Range	165.195
Interquartile range (IQR)	65.948

Descriptive statistics

Standard deviation	34.804272
Coefficient of variation (CV)	0.28127666
Kurtosis	-1.1600029
Mean	123.73679
Median Absolute Deviation (MAD)	18.326
Skewness	0.55749643
Sum	49746027
Variance	1211.3373
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
104.823	1859	0.5%
170.019	1533	0.4%
96.029	1533	0.4%
98.005	1449	0.4%
95.977	1328	0.3%
174.006	1313	0.3%
94.983	1311	0.3%
102.02	1250	0.3%
96.016	1196	0.3%
124.949	1181	0.3%
Other values (4920)	388078	96.5%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
48.936	39	< 0.1%
57.967	7	< 0.1%
62.009	1	< 0.1%
62.426	7	< 0.1%
62.484	10	< 0.1%
62.52	6	< 0.1%
62.948	7	< 0.1%
64.177	42	< 0.1%
64.921	175	< 0.1%
64.934	143	< 0.1%

Value	Count	Frequency (%)
214.131	7	< 0.1%
212.117	147	< 0.1%
212.058	7	< 0.1%
211.974	13	< 0.1%
209.733	1	< 0.1%
209.47	1	< 0.1%
209.08	2	< 0.1%
208.902	1	< 0.1%
207.923	1	< 0.1%
207.798	9	< 0.1%

af_time_signature
Categorical

IMBALANCE

Distinct	4
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	26.1 MiB

4.0	387519
3.0	10351
5.0	3013
1.0	1148

Length

Max length	3
Median length	3
Mean length	3
Min length	3

Characters and Unicode

Total characters	1206093
Distinct characters	6
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	4.0
2nd row	4.0
3rd row	4.0
4th row	4.0
5th row	4.0

Common Values

Value	Count	Frequency (%)
4.0	387519	96.4%
3.0	10351	2.6%
5.0	3013	0.7%
1.0	1148	0.3%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
4.0	387519	96.4%
3.0	10351	2.6%
5.0	3013	0.7%
1.0	1148	0.3%

Most occurring characters

Value	Count	Frequency (%)
.	402031	33.3%
0	402031	33.3%
4	387519	32.1%
3	10351	0.9%
5	3013	0.2%
1	1148	0.1%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	1206093	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
.	402031	33.3%
0	402031	33.3%
4	387519	32.1%
3	10351	0.9%
5	3013	0.2%
1	1148	0.1%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	1206093	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
.	402031	33.3%
0	402031	33.3%
4	387519	32.1%
3	10351	0.9%
5	3013	0.2%
1	1148	0.1%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	1206093	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
.	402031	33.3%
0	402031	33.3%
4	387519	32.1%
3	10351	0.9%
5	3013	0.2%
1	1148	0.1%

predicted_popularity
Categorical

HIGH CORRELATION

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	25.3 MiB

1	298641
0	103390

Length

Max length	1
Median length	1
Mean length	1
Min length	1

Characters and Unicode

Total characters	402031
Distinct characters	2
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	1
2nd row	1
3rd row	1
4th row	1
5th row	0

Common Values

Value	Count	Frequency (%)
1	298641	74.3%
0	103390	25.7%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
1	298641	74.3%
0	103390	25.7%

Most occurring characters

Value	Count	Frequency (%)
1	298641	74.3%
0	103390	25.7%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	402031	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
1	298641	74.3%
0	103390	25.7%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	402031	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
1	298641	74.3%
0	103390	25.7%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	402031	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
1	298641	74.3%
0	103390	25.7%

Auto

Heatmap
Table

	af_acousticness	af_danceability	af_energy	af_instrumentalness	af_key	af_liveness	af_loudness	af_mode	af_speechiness	af_tempo	af_time_signature	af_valence	chart_id	duration_ms	explicit	popularity	predicted_popularity	rank	streams	trend
af_acousticness	1.000	-0.036	-0.382	-0.030	0.007	0.049	-0.186	0.076	-0.025	-0.014	0.144	-0.042	0.032	0.035	0.084	0.076	0.085	0.037	0.034	0.026
af_danceability	-0.036	1.000	0.034	0.137	0.027	-0.110	0.132	0.102	0.173	-0.243	0.262	0.251	-0.039	-0.033	0.133	-0.021	0.078	-0.041	0.111	0.051
af_energy	-0.382	0.034	1.000	-0.019	-0.004	0.025	0.608	0.126	0.044	-0.019	0.179	0.331	-0.085	0.060	0.162	-0.126	0.104	-0.056	-0.012	0.044
af_instrumentalness	-0.030	0.137	-0.019	1.000	0.025	-0.039	-0.072	0.060	0.032	0.048	0.040	-0.095	0.083	-0.026	0.051	0.046	0.058	-0.040	0.057	0.022
af_key	0.007	0.027	-0.004	0.025	1.000	-0.021	0.018	0.284	0.038	-0.021	0.078	-0.006	-0.023	0.002	0.084	0.010	0.078	-0.007	0.014	0.019
af_liveness	0.049	-0.110	0.025	-0.039	-0.021	1.000	-0.039	0.056	-0.060	-0.012	0.069	-0.037	-0.002	-0.011	0.079	-0.050	0.053	0.009	-0.055	0.017
af_loudness	-0.186	0.132	0.608	-0.072	0.018	-0.039	1.000	0.038	0.077	0.011	0.097	0.349	-0.057	-0.026	0.083	-0.077	0.073	-0.054	0.141	0.051
af_mode	0.076	0.102	0.126	0.060	0.284	0.056	0.038	1.000	-0.097	0.047	0.070	-0.045	0.001	0.018	0.059	0.034	0.028	0.041	-0.016	0.012
af_speechiness	-0.025	0.173	0.044	0.032	0.038	-0.060	0.077	-0.097	1.000	0.179	0.080	0.029	-0.023	-0.032	0.137	-0.079	0.061	-0.067	0.140	0.026
af_tempo	-0.014	-0.243	-0.019	0.048	-0.021	-0.012	0.011	0.047	0.179	1.000	0.120	-0.029	0.025	-0.005	0.129	0.017	0.094	0.021	0.022	0.049
af_time_signature	0.144	0.262	0.179	0.040	0.078	0.069	0.097	0.070	0.080	0.120	1.000	0.105	-0.059	-0.008	0.058	-0.046	0.031	0.012	-0.023	0.008
af_valence	-0.042	0.251	0.331	-0.095	-0.006	-0.037	0.349	-0.045	0.029	-0.029	0.105	1.000	-0.019	-0.052	0.166	-0.049	0.092	-0.017	0.106	0.038
chart_id	0.032	-0.039	-0.085	0.083	-0.023	-0.002	-0.057	0.001	-0.023	0.025	-0.059	-0.019	1.000	-0.075	0.111	0.040	0.223	-0.146	0.306	0.040
duration_ms	0.035	-0.033	0.060	-0.026	0.002	-0.011	-0.026	0.018	-0.032	-0.005	-0.008	-0.052	-0.075	1.000	0.196	0.051	0.047	0.012	-0.068	0.017
explicit	0.084	0.133	0.162	0.051	0.084	0.079	0.083	0.059	0.137	0.129	0.058	0.166	0.111	0.196	1.000	0.063	0.019	-0.020	0.087	0.019
popularity	0.076	-0.021	-0.126	0.046	0.010	-0.050	-0.077	0.034	-0.079	0.017	-0.046	-0.049	0.040	0.051	0.063	1.000	0.949	0.138	0.109	0.058
predicted_popularity	0.085	0.078	0.104	0.058	0.078	0.053	0.073	0.028	0.061	0.094	0.031	0.092	0.223	0.047	0.019	0.949	1.000	0.130	0.166	0.056
rank	0.037	-0.041	-0.056	-0.040	-0.007	0.009	-0.054	0.041	-0.067	0.021	0.012	-0.017	-0.146	0.012	-0.020	0.138	0.130	1.000	-0.698	0.275
streams	0.034	0.111	-0.012	0.057	0.014	-0.055	0.141	-0.016	0.140	0.022	-0.023	0.106	0.306	-0.068	0.087	0.109	0.166	-0.698	1.000	0.199
trend	0.026	0.051	0.044	0.022	0.019	0.017	0.051	0.012	0.026	0.049	0.008	0.038	0.040	0.017	0.019	0.058	0.056	0.275	0.199	1.000

A simple visualization of nullity by column.

Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.

The correlation heatmap measures nullity correlation: how strongly the presence or absence of one variable affects the presence of another.

First rows
Last rows

	chart_id	title	rank	date	artist	trend	streams	track_id	album	popularity	duration_ms	explicit	af_danceability	af_energy	af_key	af_loudness	af_mode	af_speechiness	af_acousticness	af_instrumentalness	af_liveness	af_valence	af_tempo	af_time_signature	predicted_popularity
0	803	Reggaetón Lento (Bailemos)	1	2017-01-01	CNCO	SAME_POSITION	6784.0	3AEZUABDXNtecAOSC1qTfo	Primera Cita	73.0	222560.0	False	0.761	0.838	4.0	-3.073	0.0	0.0502	0.40000	0.000000	0.1760	0.710	93.974	4.0	1
1	804	Otra vez (feat. J Balvin)	2	2017-01-01	Zion & Lennox	SAME_POSITION	5748.0	3QwBODjSEzelZyVjxPOHdq	Motivan2	74.0	209453.0	False	0.832	0.772	10.0	-5.429	1.0	0.1000	0.05590	0.000486	0.4400	0.704	96.016	4.0	1
2	805	Chantaje (feat. Maluma)	3	2017-01-01	Shakira	SAME_POSITION	5506.0	6mICuAdrwEjh6Y6lroV2Kg	El Dorado	78.0	195840.0	False	0.852	0.773	8.0	-2.921	0.0	0.0776	0.18700	0.000030	0.1590	0.907	102.034	4.0	1
3	806	Vente Pa' Ca (feat. Maluma)	4	2017-01-01	Ricky Martin	MOVE_UP	4804.0	7DM4BPaS7uofFul3ywMe46	Vente Pa' Ca (feat. Maluma)	72.0	259195.0	False	0.663	0.920	11.0	-4.070	0.0	0.2260	0.00431	0.000017	0.1010	0.533	99.935	4.0	1
4	807	Traicionera	5	2017-01-01	Sebastian Yatra	MOVE_DOWN	4780.0	5J1c3M4EldCfNxXwrwt8mT	Traicionera	0.0	228466.0	False	0.776	0.669	11.0	-4.933	1.0	0.0638	0.14200	0.000000	0.2190	0.661	91.012	4.0	0
5	808	Safari	6	2017-01-01	J Balvin, Pharrell Williams, BIA, Sky	SAME_POSITION	4399.0	6rQSrBHf7HlZjtcMZ4S4bO	Energía	0.0	205600.0	False	0.508	0.687	0.0	-4.361	1.0	0.3260	0.55100	0.000003	0.1260	0.555	180.044	4.0	0
6	809	Let Me Love You	7	2017-01-01	DJ Snake, Justin Bieber	SAME_POSITION	3542.0	4pdPtRcBmOSQDlJ3Fk945m	Encore	2.0	205946.0	False	0.476	0.718	8.0	-5.309	1.0	0.0576	0.07840	0.000010	0.1220	0.142	199.864	4.0	0
7	810	La Bicicleta	8	2017-01-01	Carlos Vives, Shakira	MOVE_UP	3507.0	0sXvAOmXgjR2QUqLK1MltU	El Dorado	59.0	227706.0	False	0.736	0.964	0.0	-2.147	1.0	0.1290	0.19800	0.000002	0.3360	0.953	179.935	4.0	1
8	811	Ay Mi Dios (feat. Pitbull, Yandel & Chacal)	9	2017-01-01	IAmChino, El Chacal	MOVE_DOWN	3446.0	6stYbAJgTszHAHZMPxWWCY	Ay Mi Dios (feat. Pitbull, Yandel & Chacal)	0.0	252003.0	False	0.761	0.829	0.0	-3.203	0.0	0.0681	0.16700	0.000000	0.1890	0.813	92.033	4.0	0
9	812	Me llamas (feat. Maluma) - Remix	10	2017-01-01	Piso 21	SAME_POSITION	2979.0	5hEM0JchdVzQ5PwvSfITeX	Me Llamas (feat. Maluma) [Remix]	69.0	210322.0	False	0.760	0.838	7.0	-3.828	0.0	0.0529	0.54700	0.000001	0.0664	0.745	93.050	4.0	1

	chart_id	title	rank	date	artist	trend	streams	track_id	album	popularity	duration_ms	explicit	af_danceability	af_energy	af_key	af_loudness	af_mode	af_speechiness	af_acousticness	af_instrumentalness	af_liveness	af_valence	af_tempo	af_time_signature	predicted_popularity
404500	26171063	Poblado - Remix	38	2021-07-31	J Balvin, KAROL G, Nicky Jam, Crissin, Totoy El Frio, Natan & Shander	MOVE_DOWN	NaN	1WedZeiezCmCEOzLwhx0hV	Poblado (Remix)	68.0	393280.0	False	0.813	0.809	3.0	-5.382	0.0	0.0846	0.10200	0.000001	0.3770	0.646	93.005	4.0	1
404501	26171064	Fulanito	39	2021-07-31	Becky G, El Alfa	MOVE_UP	NaN	59L8x0xy8njj75vzVCPMqg	FULANITO	62.0	158531.0	False	0.930	0.837	7.0	-4.632	0.0	0.1870	0.25600	0.000002	0.2390	0.821	111.898	4.0	1
404503	26171066	Fairytale	41	2021-07-31	Alexander Rybak	NEW_ENTRY	NaN	5D2L026JQTKC2gcq3qkYpj	Fairytales	0.0	183093.0	False	0.587	0.715	2.0	-6.414	0.0	0.0271	0.43400	0.000018	0.3200	0.589	107.964	4.0	0
404504	26171067	Love Tonight	42	2021-07-31	Shouse	NEW_ENTRY	NaN	1u73tmG4xQschbK8cXxSD9	Love Tonight	61.0	493795.0	False	0.796	0.552	0.0	-7.226	1.0	0.0314	0.00113	0.010100	0.0876	0.468	123.004	4.0	1
404505	26171068	Space Song	43	2021-07-31	Beach House	MOVE_DOWN	NaN	7H0ya83CMmgFcOhw0UB6ow	Depression Cherry	80.0	320466.0	False	0.508	0.792	0.0	-7.311	0.0	0.0297	0.22900	0.124000	0.1450	0.601	147.067	4.0	1
404507	26171070	In Da Getto	45	2021-07-31	J Balvin, Skrillex	NEW_ENTRY	NaN	63aj87TQG6F3RVO5nbG2VQ	In Da Getto	68.0	131065.0	False	0.915	0.720	8.0	-3.126	1.0	0.0459	0.02500	0.000014	0.0942	0.631	126.986	4.0	1
404508	26171071	Bad Habits	46	2021-07-31	Ed Sheeran	NEW_ENTRY	NaN	6PQ88X9TkUIAUIZJHW2upE	Bad Habits	7.0	231041.0	False	0.808	0.897	11.0	-3.712	0.0	0.0348	0.04690	0.000031	0.3640	0.591	126.026	4.0	0
404510	26171073	Running Away	48	2021-07-31	VANO 3000, BADBADNOTGOOD, Samuel T. Herring	MOVE_DOWN	NaN	2lDODk7inZnmUHbIjUnIwP	Running Away	0.0	111786.0	False	0.580	0.696	7.0	-10.910	1.0	0.0408	0.66000	0.852000	0.1450	0.721	93.688	4.0	0
404511	26171074	Casualidad	49	2021-07-31	Sofía Reyes, Pedro Capó	NEW_ENTRY	NaN	5FcT2TuosRkokjn3xyncER	Casualidad	54.0	193112.0	False	0.753	0.720	10.0	-4.223	0.0	0.0987	0.38300	0.000000	0.0554	0.840	173.906	4.0	1
404512	26171075	Pieces	50	2021-07-31	AVAION	NEW_ENTRY	NaN	5H95n43z0KFcXGCEc0ewe1	Pieces	68.0	196413.0	False	0.700	0.271	4.0	-13.316	1.0	0.0620	0.87200	0.322000	0.1000	0.198	120.015	4.0	1

Overview

Variables

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks

Most frequent character per block

(unknown)

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks

Most frequent character per block

(unknown)

Common Values

Length

Common Values (Plot)

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks

Most frequent character per block

(unknown)

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks

Most frequent character per block

(unknown)

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks

Most frequent character per block

(unknown)

Common Values

Length

Common Values (Plot)

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks

Most frequent character per block

(unknown)

Common Values

Length

Common Values (Plot)

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks

Most frequent character per block